Aside

Contact


Coding


Visualization


Strength

Disclaimer

Made w/ pagedown.
Source code: Github repo.

Last updated on 2021-03-07.

Main

Dingrui(Frank) Zhang

Data Analyst | Accountant

I enjoy working with data to solve business problems and build tools that help people. My favorite part of working in both data and finance area is the constant opportunity to learn, from statistics and software development to real business problems as well as to use tools to communicate insights with people and help them make decisions.

Education

Master of Professional Accounting

University of New South Wales

Sydney, Australia

2019 - 2017

Exchange Student Program (Major in Accounting)

University of New South Wales

Sydney, Australia

2017 - 2016

  • Achieved Overall Distinction WAM

Bachelor of Management (Major in Accounting)

Hebei University of Economics and Business

Shijiazhuang, China

2016 - 2013

  • Achieved Overall WAM of 80

Professional Experience

Consultant, Data Analytics

PwC Australia

Sydney, Australia

Present - 2020 Jan

  • Worked on data analysis and visualisation, and bring data analytic techniques to bear on a wide variety of problems.
  • Utilised data analysis and visualisation techniques to provide clients with powerful business insight regarding their data. This would in turn help them make informed business decisions. Tools used include Alteryx, SQL, Power BI, Tableau and Qlik Sense.
  • Developed and maintained easy-to-use product and provided training and documentation for both internal and external parties. Tools used include: Google App Script, Python and VBA
  • Played a key role in mapping the existing business process of the organization with respect to data governance and management and suggesting appropriate business practices to modify them to meet their requirements.
  • Attended meetings with multiple project stakeholders including internal and external clients to gather and document detailed data requirements.

Finance Analyst

The University of Sydney

Sydney, Australia

2019 Dec - 2019 Aug

  • Designed, developed and maintained standardized budget/forecast models, tools and guidelines to improve the accuracy, consistency, timeliness and quality of budgeting and forecasting throughout the Faculties and these are continued to be used across the University faculties.
  • Performed variance analysis, trend analysis and sensitivity analysis on daily requests. Assisting Senior Financial Analyst in providing insightful analysis, to track and report financial and non-financial KPIs.
  • Improved reporting pipelines utilising VBA , SmartView and R to automate processes and provide high-level quality controls.
  • Migrated monthly financial reporting dashboards from excel-based to Power BI. The migration saved more than 50% time comparing with excel-based method
  • Assisted with the preparation of reconciliations of financial and operational data from different sources and provided recommendations to Finance Managers and Head of Schools

Data Analyst Intern

Travelzoo (NASDAQ: TZOO)

Sydney, Australia

2019 Aug - 2018 Dec

  • Developed an automated program (web scraper) that identifies and stores the marketing data in database to produce the desired reports.
  • Developed multiple macros and R scripts to collect information from multiple sources(ERP, Excel, Text …), analyse data and generate report automatically. Saved more than 50% time.
  • Collected and maintained history operation database and built up weekly operation report for the whole APAC(Asia Pacific) area.
  • Provided operations support for APAC Team, for example: overseas collection deal price point conversion.
  • Built quarterly/monthly dashboard for different countries in APAC area which provided measurements for management.

Junior Financial Analyst

UBI Logistics (Australia) Pty Ltd

Sydney, Australia

2018 Sep - 2017 Aug

  • Developed a billing system based on VBA and R which supports generating billing statements, email automation and aging analysis. This system significantly freed people from heavy and routine manual work, reduced 2 FTE (Full-time equivalent) and improved collecting accounts receivable.
  • Developed a procedure to analyse data, identify discrepancies and design reporting mechanism, which allow on-time and accurate measure of the company performance. This procedure is still utilized and has been able to recover more than 120,000 AUD in the past 1 year, which otherwise would be lost because of the information inaccuracy.
  • Built and maintained a MySQL finance database which helps finance department find discrepancies between forecast and real-time data, also responsible for designing data tables, managing permissions and setting up backups.
  • Worked as a consultant with a team of 5 co-workers from both China and Australia to establish an online invoicing system and successfully coordinated the project between finance and IT team.

Professional Development

Provisional member of Chartered Accountants ANZ

N/A

N/A

Present - 2019 Aug

CFA Level 1 Passed

CFA Institute (Click here to see badge)

N/A

Present - 2018 Aug

26 R Courses on Datacamp

Datacamp (Click here to see the list)
Courses include:

N/A

Present - 2017 Aug

  • Cleansing, Transformation and Visualization of data
  • Reporting and Visualization using Rmarkdown, ggplot2 and Shiny
  • Webscraping with R
  • Use SQL in R